// excel列名和表格列名的映射和反向映射

const columnExcelSort = [
  // 属性列在excel表中的顺序
  'paytype',
  'healthNo',
  'hospitalNum',
  'code',
  'isChouYang',
  'sex',
  'birthday',
  'age',
  'country',
  'BZYZSNL',
  'babyBirthWeight',
  'babyHospitalWeight',
  'birthArea',
  'nativePlace',
  'nation',
  'job',
  'marriage',
  'nowAddress',
  'nowAddressTel',
  'nowAddressCode',
  'hukouAddress',
  'hukouCode',
  'jobCompanyAndAddress',
  'jobTel',
  'jobCode',
  'contactName',
  'realation',
  'contactAddress',
  'contactTel',
  'inHospitalType',
  'inHospitalTime',
  'RYSJS',
  'inHospitalCate',
  'inHospitalRoom',
  'convertCategory',
  'outHospitalTime',
  'CYSJS',
  'outHospitalCate',
  'outHospitalRoom',
  'realInHospitalDays',
  'clinicDiagnosis',
  'clinicCode',
  'mainDiagnosis',
  'mainDiagnosisCode',
  'mainDiagnosisInInfo',
  'oDiagnosis1',
  'oDiagnosis1Code',
  'oDiagnosis1InInfo',
  'oDiagnosis2',
  'oDiagnosis2Code',
  'oDiagnosis2InInfo',
  'oDiagnosis3',
  'oDiagnosis3Code',
  'oDiagnosis3InInfo',
  'oDiagnosis4',
  'oDiagnosis4Code',
  'oDiagnosis4InInfo',
  'oDiagnosis5',
  'oDiagnosis5Code',
  'oDiagnosis5InInfo',
  'oDiagnosis6',
  'oDiagnosis6Code',
  'oDiagnosis6InInfo',
  'oDiagnosis7',
  'oDiagnosis7Code',
  'oDiagnosis7InInfo',
  'oDiagnosis8',
  'oDiagnosis8Code',
  'oDiagnosis8InInfo',
  'oDiagnosis9',
  'oDiagnosis9Code',
  'oDiagnosis9InInfo',
  'oDiagnosis10',
  'oDiagnosis10Code',
  'oDiagnosis10InInfo',
  'oDiagnosis11',
  'oDiagnosis11Code',
  'oDiagnosis11InInfo',
  'oDiagnosis12',
  'oDiagnosis12Code',
  'oDiagnosis12InInfo',
  'oDiagnosis13',
  'oDiagnosis13Code',
  'oDiagnosis13InInfo',
  'oDiagnosis14',
  'oDiagnosis14Code',
  'oDiagnosis14InInfo',
  'oDiagnosis15',
  'oDiagnosis15Code',
  'oDiagnosis15InInfo',
  'duOutReason',
  'duOutCode',
  'bingLi',
  'bingLiCode',
  'bingLiNo',
  'hasYaoGuoMin',
  'guoMinYao',
  'deadCheck',
  'bloodType',
  'RHBloodType',
  'keZhuRen',
  'zhuRenDoctor',
  'zhuZhiDoctor',
  'zhuYanDoctor',
  'zeRenNurse',
  'jinXiuDoctor',
  'shiXiDoctor',
  'coder',
  'bingAnQuality',
  'zhiKongDoctor',
  'zhiKongNurse',
  'zhiKongDate',
  'OPERGRPNO1',
  'opNo1Code',
  'opNo1Date',
  'opNo1Level',
  'opNo1Info',
  'opNo1Main',
  'opNo1Assit1',
  'opNo1Assit2',
  'opNo1QieKouLevel',
  'opNo1YuHeLevel',
  'opNo1MaZui',
  'opNo1MaZuiDoctor',
  'OPERGRPNO2',
  'opNo2Code',
  'opNo2Date',
  'opNo2Level',
  'opNo2Info',
  'opNo2Main',
  'opNo2Assit1',
  'opNo2Assit2',
  'opNo2QieKouLevel',
  'opNo2YuHeLevel',
  'opNo2MaZui',
  'opNo2MaZuiDoctor',
  'OPERGRPNO3',
  'opNo3Code',
  'opNo3Date',
  'opNo3Level',
  'opNo3Info',
  'opNo3Main',
  'opNo3Assit1',
  'opNo3Assit2',
  'opNo3QieKouLevel',
  'opNo3YuHeLevel',
  'opNo3MaZui',
  'opNo3MaZuiDoctor',
  'OPERGRPNO4',
  'opNo4Code',
  'opNo4Date',
  'opNo4Level',
  'opNo4Info',
  'opNo4Main',
  'opNo4Assit1',
  'opNo4Assit2',
  'opNo4QieKouLevel',
  'opNo4YuHeLevel',
  'opNo4MaZui',
  'opNo4MaZuiDoctor',
  'OPERGRPNO5',
  'opNo5Code',
  'opNo5Date',
  'opNo5Level',
  'opNo5Info',
  'opNo5Main',
  'opNo5Assit1',
  'opNo5Assit2',
  'opNo5QieKouLevel',
  'opNo5YuHeLevel',
  'opNo5MaZui',
  'opNo5MaZuiDoctor',
  'OPERGRPNO6',
  'opNo6Code',
  'opNo6Date',
  'opNo6Level',
  'opNo6Info',
  'opNo6Main',
  'opNo6Assit1',
  'opNo6Assit2',
  'opNo6QieKouLevel',
  'opNo6YuHeLevel',
  'opNo6MaZui',
  'opNo6MaZuiDoctor',
  'OPERGRPNO7',
  'opNo7Code',
  'opNo7Date',
  'opNo7Level',
  'opNo7Info',
  'opNo7Main',
  'opNo7Assit1',
  'opNo7Assit2',
  'opNo7QieKouLevel',
  'opNo7YuHeLevel',
  'opNo7MaZui',
  'opNo7MaZuiDoctor',
  'leaveHosType',
  'zhuanYanJieShou',
  'zhuanSheQuJieShou',
  'isDays31In',
  'days31InAim',
  'inHosBDays',
  'inHosBHours',
  'inHosBMinutes',
  'inHosADays',
  'inHosAHours',
  'inHosAMinutes',
  'totalCost',
  'selfCost',
  'fuWuFei',
  'zhiLiaoFei',
  'huLiFei',
  'otherCost',
  'bingLiFei',
  'shiYanShiFei',
  'yingXiangFei',
  'linChuangFei',
  'feiShouShuFei',
  'linChuangWuLiFei',
  'shouShuZhiLiaoFei',
  'maZuiFei',
  'shouShuFei',
  'kangFuFei',
  'zhongYiFei',
  'xiYaoFei',
  'kangJunYaoWuFei',
  'zhongChengYaoFei',
  'zhongCaoYaoFei',
  'bloodFei',
  'baiDanBaiFei',
  'qiuDanBaiFei',
  'ningXieYinZiFei',
  'xiBaoYinZiFei',
  'jianChaCaiLiaoFei',
  'zhiLiaoCaiLiaoFei',
  'shouShuCaiLiaoFei',
  'otherFei',
  'danBingZhong',
  'linChuangLuJing',
  'zhuanGuiInfo',
  'qJiuNums',
  'menZhenAndLeave',
  'inAndLeave',
  'shuQianShuHou',
  'linChuangBingLi',
  'fangSheBingLi',
  'qJiuChengGongNums'
]

const columnExcelMap = {
  paytype: '医疗付款方式',
  healthNo: '健康卡号',
  hospitalNum: '住院次数',
  code: '病案号',
  isChouYang: '是否被抽样',
  sex: '性别',
  birthday: '出生日期',
  age: '年龄',
  country: '国籍',
  BZYZSNL: 'BZYZSNL',
  babyBirthWeight: '新生儿出生体重',
  babyHospitalWeight: '新生儿入院体重',
  birthArea: '出生地',
  nativePlace: '籍贯',
  nation: '民族',
  job: '职业',
  marriage: '婚姻',
  nowAddress: '现住址',
  nowAddressTel: '现住址电话',
  nowAddressCode: '现住址邮编',
  hukouAddress: '户口地址',
  hukouCode: '户口邮编',
  jobCompanyAndAddress: '工作单位及地址',
  jobTel: '工作单位电话',
  jobCode: '工作单位邮编',
  contactName: '联系人姓名',
  realation: '关系',
  contactAddress: '联系人地址',
  contactTel: '联系人电话',
  inHospitalType: '入院途径',
  inHospitalTime: '入院时间',
  RYSJS: 'RYSJS',
  inHospitalCate: '入院科别',
  inHospitalRoom: '入院病房',
  convertCategory: '转科科别',
  outHospitalTime: '出院时间',
  CYSJS: 'CYSJS',
  outHospitalCate: '出院科别',
  outHospitalRoom: '出院病房',
  realInHospitalDays: '实际住院天数',
  clinicDiagnosis: '门诊诊断',
  clinicCode: '门诊诊断编码',
  mainDiagnosis: '主要诊断',
  mainDiagnosisCode: '主要诊断编码',
  mainDiagnosisInInfo: '主要诊断入院病情',
  oDiagnosis1: '其他诊断1',
  oDiagnosis1Code: '其他诊断编码1',
  oDiagnosis1InInfo: '其他诊断1入院病情',
  oDiagnosis2: '其他诊断2',
  oDiagnosis2Code: '其他诊断编码2',
  oDiagnosis2InInfo: '其他诊断2入院病情',
  oDiagnosis3: '其他诊断3',
  oDiagnosis3Code: '其他诊断编码3',
  oDiagnosis3InInfo: '其他诊断3入院病情',
  oDiagnosis4: '其他诊断4',
  oDiagnosis4Code: '其他诊断编码4',
  oDiagnosis4InInfo: '其他诊断4入院病情',
  oDiagnosis5: '其他诊断5',
  oDiagnosis5Code: '其他诊断编码5',
  oDiagnosis5InInfo: '其他诊断5入院病情',
  oDiagnosis6: '其他诊断6',
  oDiagnosis6Code: '其他诊断编码6',
  oDiagnosis6InInfo: '其他诊断6入院病情',
  oDiagnosis7: '其他诊断7',
  oDiagnosis7Code: '其他诊断编码7',
  oDiagnosis7InInfo: '其他诊断7入院病情',
  oDiagnosis8: '其他诊断8',
  oDiagnosis8Code: '其他诊断编码8',
  oDiagnosis8InInfo: '其他诊断8入院病情',
  oDiagnosis9: '其他诊断9',
  oDiagnosis9Code: '其他诊断编码9',
  oDiagnosis9InInfo: '其他诊断9入院病情',
  oDiagnosis10: '其他诊断10',
  oDiagnosis10Code: '其他诊断编码10',
  oDiagnosis10InInfo: '其他诊断10入院病情',
  oDiagnosis11: '其他诊断11',
  oDiagnosis11Code: '其他诊断编码11',
  oDiagnosis11InInfo: '其他诊断11入院病情',
  oDiagnosis12: '其他诊断12',
  oDiagnosis12Code: '其他诊断编码12',
  oDiagnosis12InInfo: '其他诊断12入院病情',
  oDiagnosis13: '其他诊断13',
  oDiagnosis13Code: '其他诊断编码13',
  oDiagnosis13InInfo: '其他诊断13入院病情',
  oDiagnosis14: '其他诊断14',
  oDiagnosis14Code: '其他诊断编码14',
  oDiagnosis14InInfo: '其他诊断14入院病情',
  oDiagnosis15: '其他诊断15',
  oDiagnosis15Code: '其他诊断编码15',
  oDiagnosis15InInfo: '其他诊断15入院病情',
  duOutReason: '损伤中毒外部原因',
  duOutCode: '损伤中毒外部原因编码',
  bingLi: '病理诊断',
  bingLiCode: '病理诊断编码',
  bingLiNo: '病理号',
  hasYaoGuoMin: '药物过敏',
  guoMinYao: '过敏药物',
  deadCheck: '死亡患者尸检',
  bloodType: '血型',
  RHBloodType: 'RH血型',
  keZhuRen: '科主任',
  zhuRenDoctor: '主任医师',
  zhuZhiDoctor: '主治医师',
  zhuYanDoctor: '住院医师',
  zeRenNurse: '责任护士',
  jinXiuDoctor: '进修医师',
  shiXiDoctor: '实习医师',
  coder: '编码员',
  bingAnQuality: '病案质量',
  zhiKongDoctor: '质控医师',
  zhiKongNurse: '质控护士',
  zhiKongDate: '质控日期',
  OPERGRPNO1: 'OPERGRPNO1',
  opNo1Code: '手术及操作编码1',
  opNo1Date: '手术及操作日期1',
  opNo1Level: '手术级别1',
  opNo1Info: '手术及操作名称1',
  opNo1Main: '手术1主刀',
  opNo1Assit1: '手术1助手1',
  opNo1Assit2: '手术1助手2',
  opNo1QieKouLevel: '手术1切口等级',
  opNo1YuHeLevel: '手术1愈合等级',
  opNo1MaZui: '手术1麻醉方式',
  opNo1MaZuiDoctor: '手术1麻醉医师',
  OPERGRPNO2: 'OPERGRPNO2',
  opNo2Code: '手术及操作编码2',
  opNo2Date: '手术及操作日期2',
  opNo2Level: '手术级别2',
  opNo2Info: '手术及操作名称2',
  opNo2Main: '手术2主刀',
  opNo2Assit1: '手术2助手1',
  opNo2Assit2: '手术2助手2',
  opNo2QieKouLevel: '手术2切口等级',
  opNo2YuHeLevel: '手术2愈合等级',
  opNo2MaZui: '手术2麻醉方式',
  opNo2MaZuiDoctor: '手术2麻醉医师',
  OPERGRPNO3: 'OPERGRPNO3',
  opNo3Code: '手术及操作编码3',
  opNo3Date: '手术及操作日期3',
  opNo3Level: '手术级别3',
  opNo3Info: '手术及操作名称3',
  opNo3Main: '手术3主刀',
  opNo3Assit1: '手术3助手1',
  opNo3Assit2: '手术3助手2',
  opNo3QieKouLevel: '手术3切口等级',
  opNo3YuHeLevel: '手术3愈合等级',
  opNo3MaZui: '手术3麻醉方式',
  opNo3MaZuiDoctor: '手术3麻醉医师',
  OPERGRPNO4: 'OPERGRPNO4',
  opNo4Code: '手术及操作编码4',
  opNo4Date: '手术及操作日期4',
  opNo4Level: '手术级别4',
  opNo4Info: '手术及操作名称4',
  opNo4Main: '手术4主刀',
  opNo4Assit1: '手术4助手1',
  opNo4Assit2: '手术4助手2',
  opNo4QieKouLevel: '手术4切口等级',
  opNo4YuHeLevel: '手术4愈合等级',
  opNo4MaZui: '手术4麻醉方式',
  opNo4MaZuiDoctor: '手术4麻醉医师',
  OPERGRPNO5: 'OPERGRPNO5',
  opNo5Code: '手术及操作编码5',
  opNo5Date: '手术及操作日期5',
  opNo5Level: '手术级别5',
  opNo5Info: '手术及操作名称5',
  opNo5Main: '手术5主刀',
  opNo5Assit1: '手术5助手1',
  opNo5Assit2: '手术5助手2',
  opNo5QieKouLevel: '手术5切口等级',
  opNo5YuHeLevel: '手术5愈合等级',
  opNo5MaZui: '手术5麻醉方式',
  opNo5MaZuiDoctor: '手术5麻醉医师',
  OPERGRPNO6: 'OPERGRPNO6',
  opNo6Code: '手术及操作编码6',
  opNo6Date: '手术及操作日期6',
  opNo6Level: '手术级别6',
  opNo6Info: '手术及操作名称6',
  opNo6Main: '手术6主刀',
  opNo6Assit1: '手术6助手1',
  opNo6Assit2: '手术6助手2',
  opNo6QieKouLevel: '手术6切口等级',
  opNo6YuHeLevel: '手术6愈合等级',
  opNo6MaZui: '手术6麻醉方式',
  opNo6MaZuiDoctor: '手术6麻醉医师',
  OPERGRPNO7: 'OPERGRPNO7',
  opNo7Code: '手术及操作编码7',
  opNo7Date: '手术及操作日期7',
  opNo7Level: '手术级别7',
  opNo7Info: '手术及操作名称7',
  opNo7Main: '手术7主刀',
  opNo7Assit1: '手术7助手1',
  opNo7Assit2: '手术7助手2',
  opNo7QieKouLevel: '手术7切口等级',
  opNo7YuHeLevel: '手术7愈合等级',
  opNo7MaZui: '手术7麻醉方式',
  opNo7MaZuiDoctor: '手术7麻醉医师',
  leaveHosType: '离院方式',
  zhuanYanJieShou: '医嘱转院拟接收医疗机构',
  zhuanSheQuJieShou: '医嘱转社区拟接收医疗机构',
  isDays31In: '是否31天再入院',
  days31InAim: '31天再入院目的',
  inHosBDays: '入院前昏迷天数',
  inHosBHours: '入院前昏迷小时',
  inHosBMinutes: '入院前昏迷分钟',
  inHosADays: '入院后昏迷天数',
  inHosAHours: '入院后昏迷小时',
  inHosAMinutes: '入院后昏迷分钟',
  totalCost: '总费用',
  selfCost: '自付金额',
  fuWuFei: '一般医疗服务费',
  zhiLiaoFei: '一般治疗操作费',
  huLiFei: '护理费',
  otherCost: '其他费用',
  bingLiFei: '病历诊断费',
  shiYanShiFei: '实验室诊断费',
  yingXiangFei: '影像学诊断费',
  linChuangFei: '临床诊断项目费',
  feiShouShuFei: '非手术治疗项目费',
  linChuangWuLiFei: '临床物理治疗费',
  shouShuZhiLiaoFei: '手术治疗费',
  maZuiFei: '麻醉费',
  shouShuFei: '手术费',
  kangFuFei: '康复费',
  zhongYiFei: '中医治疗费',
  xiYaoFei: '西药费',
  kangJunYaoWuFei: '抗菌药物费',
  zhongChengYaoFei: '中成药费',
  zhongCaoYaoFei: '中草药费',
  bloodFei: '血费',
  baiDanBaiFei: '白蛋白类制品费',
  qiuDanBaiFei: '球蛋白类制品费',
  ningXieYinZiFei: '凝血因子类制品费',
  xiBaoYinZiFei: '细胞因子类制品费',
  jianChaCaiLiaoFei: '检查用一次性医用材料费',
  zhiLiaoCaiLiaoFei: '治疗用一次性医用材料费',
  shouShuCaiLiaoFei: '手术用一次性医用材料费',
  otherFei: '其他费',
  danBingZhong: '单病种管理',
  linChuangLuJing: '临床路径管理',
  zhuanGuiInfo: '转归情况',
  qJiuNums: '抢救次数',
  menZhenAndLeave: '门诊与出院',
  inAndLeave: '入院与出院',
  shuQianShuHou: '术前与术后',
  linChuangBingLi: '临床与病理',
  fangSheBingLi: '放射与病理',
  qJiuChengGongNums: '抢救成功次数'
}
const excelColumnMap = {}
for (const [key, value] of Object.entries(columnExcelMap)) {
  excelColumnMap[value] = key
}

module.exports = {
  columnExcelMap,
  excelColumnMap,
  columnExcelSort
}
